Is Dumbledore as great as he seems?

Is Dumbledore as great as he seems?